package com.wybx.mapper;

import com.wybx.pojo.Student;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface XszcMapper {
    @Select("select r.id, nsi.XM from register r left join new_student_info nsi on r.KSH = nsi.KSH where r.id = #{id} order by r.id desc limit 1")
    Student getNameList(@Param("id") int id);

    @Select("select max(id) from register")
    Integer getRegisterMaxId();
}
